﻿CREATE TABLE [dbo].[tblHoSoCn]
(
[Ma_HsCn] [nvarchar] (10) NOT NULL,
[Ho_Ten] [nvarchar] (63) NOT NULL,
[Ngay_Sinh] [smalldatetime]  NULL,
[Gioi_Tinh] [nvarchar] (5) NOT NULL,
[Dan_Toc] [nvarchar] (47) NOT NULL,
[Quoc_Tich] [nvarchar] (47) NOT NULL,
[So_Cmnd] [nvarchar] (12) NOT NULL,
[Ngay_Cmnd] [smalldatetime] NOT NULL,
[Noi_Cmnd] [nvarchar] (47) NOT NULL,
[Ten_Gtk] [nvarchar] (47) NOT NULL,
[So_GtK] [nvarchar] (23) NOT NULL,
[Ngay_Gtk] [smalldatetime]  NULL,
[Han_Gtk] [smalldatetime]  NULL,
[Noi_Gtk] [nvarchar] (47)  NULL,
[HoKhau_Tt] [nvarchar] (127) NOT NULL,
[NoiO_Ht] [nvarchar] (127) NOT NULL,
[Dien_Thoai] [nvarchar] (47) NOT NULL,
[Fax] [nvarchar] (47) NOT NULL,
[Email] [nvarchar] (47) NOT NULL,
[WebSite] [nvarchar] (47)  NULL,
[User0] [nvarchar] (23) NOT NULL,
[Date0] [datetime] NOT NULL,
[Client0] [nvarchar] (47) NOT NULL
) ON [PRIMARY]


